UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RfV8TKeqmF8bjDfWGkPNK3FkO7CV2pNa2y9figBTtos='
WHERE
key_id = 'edfc739b85536a4c4e910c143d3d52b5cd96631b0fd662498bf54b96ba87dbac'
AND (
token = 'RfV8TKeqmF8bjDfWGkPNK3FkO7CV2pNa2y9figBTtos='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)