UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c4d1KqJHB2bddmeJNecd2DS5/eRjpDhXNV/QCGULv7U='
WHERE
key_id = '942ed12fddb0bdc69ef76a7d93473391baf2a447c12dc63885c3a5711fddc19c'
AND (
token = 'c4d1KqJHB2bddmeJNecd2DS5/eRjpDhXNV/QCGULv7U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)