UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6KXX+9XOw0ky8hTO3NEyk9E/XV6uKpuaA1CE2qLpql0='
WHERE
key_id = '33671f9f42c4e7f459e7829ba7f7594c958a01c16499a55b3ee62aefea74cf7d'
AND (
token = '6KXX+9XOw0ky8hTO3NEyk9E/XV6uKpuaA1CE2qLpql0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)