UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cQfEv5QLL2ZOJ9MGSJuOWOhKndhVe4M+J87QCm83ayk='
WHERE
key_id = 'a51550f9d911c6239972fd2e3fc167aaade8bcc1bcae7e215d16934aad98a249'
AND (
token = 'cQfEv5QLL2ZOJ9MGSJuOWOhKndhVe4M+J87QCm83ayk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)