UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VZiJ5BTthetUGMYHnqr0MB+jMZIh4necyryHQcjYxnE='
WHERE
key_id = 'dcce75858d26678b00f310f3dfa54e68c70f411dd2dc39e674230ee6978eb98e'
AND (
token = 'VZiJ5BTthetUGMYHnqr0MB+jMZIh4necyryHQcjYxnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)