UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Tb7xDARLr314fXSvQeeeLvEFlOALccgEuu1HfPCQEY='
WHERE
key_id = 'a7170a6e5d5e6e7623f8c18e8498ad6812a2eada674c93dffc073673b2ae25ce'
AND (
token = '2Tb7xDARLr314fXSvQeeeLvEFlOALccgEuu1HfPCQEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)