UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GiyCgejEjlzffQOX2oYXiWjC4JOf6KZWgaaRDsKZM2k='
WHERE
key_id = '10c74c9478a64b955927f79fd74f16be3b2c43716cb1c6c780d32935f06116a8'
AND (
token = 'GiyCgejEjlzffQOX2oYXiWjC4JOf6KZWgaaRDsKZM2k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)