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