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