UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v5CQqOXwPJS+7FXCm8sXt3flZgf15lRIMsWw9D1DHv8='
WHERE
key_id = 'c39b45bde4eb939b66285b909822bacb149241ec36415793f1874f014b7a10ac'
AND (
token = 'v5CQqOXwPJS+7FXCm8sXt3flZgf15lRIMsWw9D1DHv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)