UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/roekw3dFzWvlbZkzFuDzS2QcoElzG11mTn9KtmECqM='
WHERE
key_id = '173c010eade0d605210342263c382568df0ffe3f95ce27ad0a156e78bea8859d'
AND (
token = '/roekw3dFzWvlbZkzFuDzS2QcoElzG11mTn9KtmECqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)