UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q6cPw7PWwqbykaoeVQPxBLem9Nl3xeI/Ze3B4R13UPI='
WHERE
key_id = '16e4852e9e132c57713fbad788707922291dd0dd29a33a15776b1459b6801f7b'
AND (
token = 'q6cPw7PWwqbykaoeVQPxBLem9Nl3xeI/Ze3B4R13UPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)