UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'spi4XmHnsqXyBwTYcfIVREZTBeZW+ydx6MhQf9QV1Cw='
WHERE
key_id = 'f801afad827b495fab6a5a6cd0d7520e03a2148b89e673c363344452a0974b9d'
AND (
token = 'spi4XmHnsqXyBwTYcfIVREZTBeZW+ydx6MhQf9QV1Cw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)