UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7o1yAH/2V0KGG0JcfLDSh4MkxjWtBgauRUyR7M7Dyc8='
WHERE
key_id = 'f38ff2d49638fe0e92b1c66ea25d03de2946aceb89c523f352ea6527b89bda1c'
AND (
token = '7o1yAH/2V0KGG0JcfLDSh4MkxjWtBgauRUyR7M7Dyc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)