UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f9P4iWRTYrVLXyTiEHPHNkyTsVXCtpE9IDoeG2H9thE='
WHERE
key_id = '8434aa67fcaca8fd0e101766afbe90493e4b81b296788931bd12d45f0016dce0'
AND (
token = 'f9P4iWRTYrVLXyTiEHPHNkyTsVXCtpE9IDoeG2H9thE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)