UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XAw/kwElnz8k9Cq3nlN9SObqazCrJ5mCmImAKnNno6U='
WHERE
key_id = '174c28e92b505438844805146c95d16ab64337f6ab2125aa9b78eed8fd2bf0d2'
AND (
token = 'XAw/kwElnz8k9Cq3nlN9SObqazCrJ5mCmImAKnNno6U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)