UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2PcxyOsxq0sjW5eqYBY/txLrSICQtFljXb+CRA8S/bI='
WHERE
key_id = '0fcdb0a4a154b72716009070b618507d9fde1f9f9ce51b2c3793c88bc31c77ae'
AND (
token = '2PcxyOsxq0sjW5eqYBY/txLrSICQtFljXb+CRA8S/bI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)