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