UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k1I9ALFFD0kg5oNA1KcTE2K/yAIYF2wcutGYOohtQF4='
WHERE
key_id = 'bc7aef595ace263f9f38ca15ef796c269a7351b5b3a19ed9d79ad8d89e334edd'
AND (
token = 'k1I9ALFFD0kg5oNA1KcTE2K/yAIYF2wcutGYOohtQF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)