UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UzHwQftOPCZtwMo627tiDRKsKy8P722pK7ykcRbZayg='
WHERE
key_id = 'de117c655523f64529924e841bfd089b08efa2fbd115e2b5dbc3b3fdd3b0e3fc'
AND (
token = 'UzHwQftOPCZtwMo627tiDRKsKy8P722pK7ykcRbZayg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)