UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kj0KaY2z4dTQcIcUeMzzCSPspJs78pLGjk0dgSEKTCw='
WHERE
key_id = '34e1dcf98cda607fcf91ca29557e76432113cbbcd0a08156dfd18831b03da662'
AND (
token = 'kj0KaY2z4dTQcIcUeMzzCSPspJs78pLGjk0dgSEKTCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)