UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hj04xWmWqDtTnStEosDmwJ5ZiUx0uMD6c+2TEpTY2is='
WHERE
key_id = 'b8510cd6e50979602f98034b4a9b92d10ab26bcad67f5bf0402aca731efd1f4b'
AND (
token = 'Hj04xWmWqDtTnStEosDmwJ5ZiUx0uMD6c+2TEpTY2is='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)