UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gALYU87p03nr8b26U3P6OU0rfmnmfqoyzMtsgPxT924='
WHERE
key_id = '9236cf3e0fb9b04b738de0500dbf0301d4847ff713afb88a4bba9e692a022839'
AND (
token = 'gALYU87p03nr8b26U3P6OU0rfmnmfqoyzMtsgPxT924='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)