UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EXZyyy35QapL8HDreQosMJWHMm7Huod4OStfwZY9wS8='
WHERE
key_id = '4cae5c2d5559ad188f655d39df121a0b8c7cc0e721bbd9d2b3a47a8d4c89af3b'
AND (
token = 'EXZyyy35QapL8HDreQosMJWHMm7Huod4OStfwZY9wS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)