UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd+9HxvEOMUeUo24z+tRkkzauF9udmcDLFa/psLWImW0='
WHERE
key_id = '6fc989bad8d7e8b0ad65c0e0792f05ba0ef94a4fedeb6f049f1796d7fae1cc05'
AND (
token = 'd+9HxvEOMUeUo24z+tRkkzauF9udmcDLFa/psLWImW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)