UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HTu8WOmQq6z3czEuIxLGLsEtq1r9HJjrGdFTi2GuoYA='
WHERE
key_id = 'b391636b9fbe17b6827923f6efc983f9f9753866446eedd3941a1b7e6fff4690'
AND (
token = 'HTu8WOmQq6z3czEuIxLGLsEtq1r9HJjrGdFTi2GuoYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)