UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RPWW7bh12r2krX89YDX1uNQjUhINYa8aIuYsA0QpUZQ='
WHERE
key_id = '578e5229712274d9e28267893137e27f2b01fe739b1f4f701ecd02cca18e3728'
AND (
token = 'RPWW7bh12r2krX89YDX1uNQjUhINYa8aIuYsA0QpUZQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)