UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fnyST5Tde0GJSM6FChZujMHlwq2jp26tjuxsXb40Rsw='
WHERE
key_id = '84ca3c08e5651a56a35c236fe63fd954241eb6be26eb3dd7af163e3100665547'
AND (
token = 'fnyST5Tde0GJSM6FChZujMHlwq2jp26tjuxsXb40Rsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)